| ColumnName |
Domain |
Datatype |
NULL |
Definition |
| Build |
|
int |
NO |
Identifies the build number and patch level of the software that inserted/updated this row. |
| TouchedBy |
|
varchar(50) |
NO |
Information about the user that last updated the row. |
| TouchedWhenUTC |
|
datetimeoffset(3) |
NO |
The date and time that the row was last updated and will be based on the Enterprise time zone. |
| CreatedBy |
|
varchar(50) |
NO |
Information about the user that created the row. |
| CreatedWhenUTC |
|
datetimeoffset(3) |
NO |
The date and time that the row was created and will be based on the Enterprise time zone. |
| MSRowVersion |
|
timestamp |
NO |
Optimistic lock identifier using rowversion datatype. |
| MSReplrowguid |
|
uniqueidentifier |
NO |
Unique GUID used to support merge replication. |
EpisodeManualStatementDatesID |
|
bigint |
NO |
Store auto generated unique primary value. |
EpisodeID |
|
bigint |
NO |
Store the value of EpisodeID |
EpisodeYear |
|
int |
NO |
Store the year in which the episode is created |
| FromDate |
|
date |
NO |
Store the From Date selected by user |
| ThroughDate |
|
date |
NO |
Store the Through Date selected by user |
| ClaimKey |
|
varchar(200) |
NO |
Stores the Unique ClaimKey value |